MySql_fetch_array() error in PHP

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • debajyoti2040
    New Member
    • Nov 2006
    • 1
    #1

    MySql_fetch_array() error in PHP

    In config.php line 28 I have written the following lines.
    $query = "SELECT * FROM `users` WHERE username = '".$uname."' AND password = '".$pword."' ";
    # set a query

    $online = mysql_fetch_arr ay(mysql_query( $query));

    Using MYSQL and PHP in a remote linux server I am getting the following error.
    Warning: mysql_fetch_arr ay(): supplied argument is not a valid MySQL result resource in /home/india/public_html/xxxxx/auth/config.php on line 28

    Can anybody advice , why I am getting the error.
    Tags: None
    • ronverdonk
      Recognized Expert Specialist
      • Jul 2006
      • 4259
      #2
      It most likely means you have an error in the mysql_select because no object was created. Statement of warning: do never nest mysql queries, like you do here, because you can't get to the error that caused it. Instead display the errors and continue depending on the result, like in the following sample:[php]$query = "SELECT * FROM `users` WHERE username = '$uname' AND password = '$pword';
      $res = mysql_query($qu ery)
      or die("Error in select: " . mysql_error());
      if (mysql_num_rows > 0)
      $online = mysql_fetch_arr ay($res);
      else
      echo 'No records available';[/php]
      Ronald :cool:

        Comment

        • Nert
          New Member
          • Nov 2006
          • 64
          #3
          Hi...(^_^)

          hi Sir Ronald,

          i just edited something on your post at the line "if(mysql_num_r ows > 0)". (^_^)

          [php]
          $query = "SELECT * FROM `users` WHERE username = '$uname' AND password = '$pword';
          $res = mysql_query($qu ery)
          or die("Error in select: " . mysql_error());
          if (mysql_num_rows ($res) > 0)
          $online = mysql_fetch_arr ay($res);
          else
          echo 'No records available';[/php]


          --nert
          Last edited by Nert; Nov 22 '06, 05:06 AM. Reason: my reply appears mess..

            Comment

            • ronverdonk
              Recognized Expert Specialist
              • Jul 2006
              • 4259
              #4
              Originally posted by Nert
              hi Sir Ronald,

              i just edited something on your post at the line "if(mysql_num_r ows > 0)". (^_^)

              [php]
              $query = "SELECT * FROM `users` WHERE username = '$uname' AND password = '$pword';
              $res = mysql_query($qu ery)
              or die("Error in select: " . mysql_error());
              if (mysql_num_rows ($res) > 0)
              $online = mysql_fetch_arr ay($res);
              else
              echo 'No records available';[/php]


              --nert
              You are right, thanks.

              Ronald :cool:

                Comment

                Previous template Next
                Working...